fade into obscurity

The point in which someone was once famous or well-known, has ceased being relevant in pop culture - leaving them only to be occasionally referenced to in obscure references or jokes, making them fodder for the "where are they now?" file This usually follows subsequently after that famous person's final attempt at retaining relevance in the cultural spotlight fails miserably, also known as jumping the shark. This is especially true for one hit wonders.